﻿

-- 人员班次信息修改
create procedure [dbo].[BcInfo_Update]
@bcid int,
@sjd1ks varchar(6),
@sjd1js varchar(6),
@sjd2ks varchar(6)=null,
@sjd2js varchar(6)=null,
@sjd3ks varchar(6)=null,
@sjd3js varchar(6)=null,
@sjd4ks varchar(6)=null,
@sjd4js varchar(6)=null
as
update Bc_Info
set sjd1ks=@sjd1ks,sjd1js=@sjd1js,sjd2ks=@sjd2ks,sjd2js=@sjd2js,
	sjd3ks=@sjd3ks,sjd3js=@sjd3js,sjd4ks=@sjd4ks,sjd4js=@sjd4js
where bcid=@bcid